package com.showde.shoppingmall.db.constant;

public class ProductAHRConstant extends ConstantBase {

	public static final String TABLENAME = "t_product_ahr";

	public static final String PRODUCTID = "PRODUCTID"; // 商品ID
	public static final String PRODUCTNAME = "PRODUCTNAME"; // 商品名称
	public static final String PRODUCTLOGO = "PRODUCTLOGO"; // 商品图标
	public static final String PRODUCTTITLE = "PRODUCTTITLE"; // 商品描述
	public static final String PRODUCTPRICE = "PRODUCTPRICE"; // 商品价格
	public static final String PRODUCTCATEGORYID = "PRODUCTCATEGORYID"; // 商品类别ID
	public static final String PRODUCTISHOT = "PRODUCTISHOT"; // 是否热门
	public static final String PRODUCTISADVERTISEMENT = "PRODUCTISADVERTISEMENT"; // 是否广告商品
	public static final String PRODUCTRANK = "PRODUCTRANK";// 人气值

	public static final int COLUMN_PRODUCTID = 1; // 商品ID
	public static final int COLUMN_PRODUCTNAME = 2; // 商品名称
	public static final int COLUMN_PRODUCTLOGO = 3; // 商品图标
	public static final int COLUMN_PRODUCTTITLE = 4; // 商品描述
	public static final int COLUMN_PRODUCTPRICE = 5; // 商品价格
	public static final int COLUMN_PRODUCTCATEGORYID = 6; // 商品类别ID
	public static final int COLUMN_PRODUCTISHOT = 7; // 是否热门
	public static final int COLUMN_PRODUCTISADVERTISEMENT = 8; // 是否广告商品
	public static final int COLUMN_PRODUCTRANK = 9; // 人气值

	public static final String[] dbColumns = new String[] { PRODUCTID,
			PRODUCTNAME, PRODUCTLOGO, PRODUCTTITLE, PRODUCTPRICE,
			PRODUCTCATEGORYID, PRODUCTISHOT, PRODUCTISADVERTISEMENT,
			PRODUCTRANK };

	public static final String SQL_CREAT = "create table 't_product_ahr'("
			+ "'_id' int primary key, " + "'PRODUCTID' int not null unique, "
			+ "'PRODUCTNAME' varchar(60), " + "'PRODUCTLOGO' varchar(200) , "
			+ "'PRODUCTTITLE' varchar(100), " + "'PRODUCTPRICE' float , "
			+ "'PRODUCTCATEGORYID' varchar(20), " + "'PRODUCTISHOT' int , "
			+ "'PRODUCTISADVERTISEMENT' int , " + "'PRODUCTRANK' int)";

}
